Hệ thống quản lý phương tiện trong PHP
1 <?php
2 $connection=mysqli_connect("localhost","root","","vehiclemanagement");
3
4 session_start();
5 $msg="";
6
7 if(isset($_POST['submit'])){
8 $firstname= mysqli_real_escape_string($connection,strtolower($_POST['firstname']));
9 $lastname= mysqli_real_escape_string($connection,strtolower($_POST['lastname']));
10 $email= mysqli_real_escape_string($connection,strtolower($_POST['email']));
11 $username= mysqli_real_escape_string($connection,strtolower($_POST['username']));
12 $password= mysqli_real_escape_string($connection,strtolower($_POST['password']));
13
14
15 $signup_query= "INSERT INTO `user`(`user_id`, `first_name`, `last_name`, `email`, `username`, `password`) VALUES ('','$firstname','$lastname','$email','$username','$password')";
16
17 $check_query= "SELECT * FROM `user` WHERE username='$username' or email='$email'";
18
19 $check_res=mysqli_query($connection,$check_query);
20
21 if(mysqli_num_rows($check_res)>0){
22 $msg= '<div class="alert alert-warning" style="margin-top:30px";>
23 <strong>Failed!</strong> Username or Email already exists.
24 </div>';
25
26 }
27
28 else{
29 $signup_res= mysqli_query($connection,$signup_query);
30 $msg= '<div class="alert alert-success" style="margin-top:30px";>
31 <strong>Success!</strong> Registration Succefull.
32 </div>';
33
34 }
35
36 }
37
38 ?>
39
40
41
42 <!DOCTYPE html>
43 <html lang="en">
44 <head>
45 <meta charset="UTF-8">
46 <title>Sign Up</title>
47 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
48 <link rel="stylesheet" href="swal/sweetalert.css">
49 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
50 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
51 <script src="swal/sweetalert.js"></script>
52 <link rel="stylesheet" href="animate.css">
53 <link rel="stylesheet" href="style.css">
54 </head>
55 <body data-spy="scroll" data-target=".navbar" data-offset="50">
56 <?php include 'navbar.php';?>
57
58
59
60
61
62
63 <br>
64 <div class="container">
65 <div class="row">
66 <div class="col-md-3"></div>
67 <div class="col-md-6">
68 <?php echo $msg; ?>
69 <div class="page-header">
70 <h1 style="text-align: center;">Sign Up</h1>
71 </div>
72 <form class="form-horizontal animated bounce" action="" method="post">
73 <div class="input-group">
74 <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
75 <input id="firstname" type="text" class="form-control" name="firstname" placeholder="First Name">
76 </div>
77 <br>
78 <div class="input-group">
79 <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
80 <input id="lastname" type="text" class="form-control" name="lastname" placeholder="Lastname">
81 </div>
82 <br>
83 <div class="input-group">
84 <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
85 <input id="email" type="email" class="form-control" name="email" placeholder="Email">
86 </div>
87 <br>
88 <div class="input-group">
89 <span class="input-group-addon"><i class="glyphicon glyphicon-user"></i></span>
90 <input id="username" type="text" class="form-control" name="username" placeholder="Username">
91 </div>
92 <br>
93 <div class="input-group">
94 <span class="input-group-addon"><i class="glyphicon glyphicon-lock"></i></span>
95 <input id="password" type="password" class="form-control" name="password" placeholder="Password">
96 </div>
97 <br>
98
99 <div class="input-group">
100 <button type="submit" name="submit" class="btn btn-success">Sign Up</button>
101
102 </div>
103
104 </form>
105 </div>
106 <div class="col-md-3"></div>
107
108 </div>
109
110 </div>
111
112
113
114 </body>
115 </html>